latch: cache buffers chains
Short Description
Waiting on the latch controlling a section of the buffer cache.
Detailed Description​
In most cases, the our aim is to reduce the time waiting for something other than CPU. Waiting on a latch is example of that. The 'cache buffer chains' latch is when you've got lots of people competing for access to a common place in memory, so someone has to wait for someone else to finish.
How to reduce this wait​
A common cause is poorly running queries that do lots of repeated access (ie, nested loops) to a small set of blocks in the buffer cache. Alter your SQL to reduce the contention.
Additional Links​
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.